package com.yunjian.core.busi.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HouseBasicInfoExample {
    /**
	 * @mbggenerated
	 */
	protected String orderByClause;
	/**
	 * @mbggenerated
	 */
	protected boolean distinct;
	/**
	 * @mbggenerated
	 */
	protected List<Criteria> oredCriteria;

	/**
	 * @mbggenerated
	 */
	public HouseBasicInfoExample() {
		oredCriteria = new ArrayList<Criteria>();
	}

	/**
	 * @mbggenerated
	 */
	public void setOrderByClause(String orderByClause) {
		this.orderByClause = orderByClause;
	}

	/**
	 * @mbggenerated
	 */
	public String getOrderByClause() {
		return orderByClause;
	}

	/**
	 * @mbggenerated
	 */
	public void setDistinct(boolean distinct) {
		this.distinct = distinct;
	}

	/**
	 * @mbggenerated
	 */
	public boolean isDistinct() {
		return distinct;
	}

	/**
	 * @mbggenerated
	 */
	public List<Criteria> getOredCriteria() {
		return oredCriteria;
	}

	/**
	 * @mbggenerated
	 */
	public void or(Criteria criteria) {
		oredCriteria.add(criteria);
	}

	/**
	 * @mbggenerated
	 */
	public Criteria or() {
		Criteria criteria = createCriteriaInternal();
		oredCriteria.add(criteria);
		return criteria;
	}

	/**
	 * @mbggenerated
	 */
	public Criteria createCriteria() {
		Criteria criteria = createCriteriaInternal();
		if (oredCriteria.size() == 0) {
			oredCriteria.add(criteria);
		}
		return criteria;
	}

	/**
	 * @mbggenerated
	 */
	protected Criteria createCriteriaInternal() {
		Criteria criteria = new Criteria();
		return criteria;
	}

	/**
	 * @mbggenerated
	 */
	public void clear() {
		oredCriteria.clear();
		orderByClause = null;
		distinct = false;
	}

	/**
	 * This class was generated by MyBatis Generator. This class corresponds to the database table house_basic_info
	 * @mbggenerated
	 */
	protected abstract static class GeneratedCriteria {
		protected List<Criterion> criteria;

		protected GeneratedCriteria() {
			super();
			criteria = new ArrayList<Criterion>();
		}

		public boolean isValid() {
			return criteria.size() > 0;
		}

		public List<Criterion> getAllCriteria() {
			return criteria;
		}

		public List<Criterion> getCriteria() {
			return criteria;
		}

		protected void addCriterion(String condition) {
			if (condition == null) {
				throw new RuntimeException("Value for condition cannot be null");
			}
			criteria.add(new Criterion(condition));
		}

		protected void addCriterion(String condition, Object value,
				String property) {
			if (value == null) {
				throw new RuntimeException("Value for " + property
						+ " cannot be null");
			}
			criteria.add(new Criterion(condition, value));
		}

		protected void addCriterion(String condition, Object value1,
				Object value2, String property) {
			if (value1 == null || value2 == null) {
				throw new RuntimeException("Between values for " + property
						+ " cannot be null");
			}
			criteria.add(new Criterion(condition, value1, value2));
		}

		public Criteria andIdIsNull() {
			addCriterion("ID is null");
			return (Criteria) this;
		}

		public Criteria andIdIsNotNull() {
			addCriterion("ID is not null");
			return (Criteria) this;
		}

		public Criteria andIdEqualTo(String value) {
			addCriterion("ID =", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotEqualTo(String value) {
			addCriterion("ID <>", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdGreaterThan(String value) {
			addCriterion("ID >", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdGreaterThanOrEqualTo(String value) {
			addCriterion("ID >=", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdLessThan(String value) {
			addCriterion("ID <", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdLessThanOrEqualTo(String value) {
			addCriterion("ID <=", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdLike(String value) {
			addCriterion("ID like", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotLike(String value) {
			addCriterion("ID not like", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdIn(List<String> values) {
			addCriterion("ID in", values, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotIn(List<String> values) {
			addCriterion("ID not in", values, "id");
			return (Criteria) this;
		}

		public Criteria andIdBetween(String value1, String value2) {
			addCriterion("ID between", value1, value2, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotBetween(String value1, String value2) {
			addCriterion("ID not between", value1, value2, "id");
			return (Criteria) this;
		}

		public Criteria andCityAreaIsNull() {
			addCriterion("CITY_AREA is null");
			return (Criteria) this;
		}

		public Criteria andCityAreaIsNotNull() {
			addCriterion("CITY_AREA is not null");
			return (Criteria) this;
		}

		public Criteria andCityAreaEqualTo(String value) {
			addCriterion("CITY_AREA =", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaNotEqualTo(String value) {
			addCriterion("CITY_AREA <>", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaGreaterThan(String value) {
			addCriterion("CITY_AREA >", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaGreaterThanOrEqualTo(String value) {
			addCriterion("CITY_AREA >=", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaLessThan(String value) {
			addCriterion("CITY_AREA <", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaLessThanOrEqualTo(String value) {
			addCriterion("CITY_AREA <=", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaLike(String value) {
			addCriterion("CITY_AREA like", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaNotLike(String value) {
			addCriterion("CITY_AREA not like", value, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaIn(List<String> values) {
			addCriterion("CITY_AREA in", values, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaNotIn(List<String> values) {
			addCriterion("CITY_AREA not in", values, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaBetween(String value1, String value2) {
			addCriterion("CITY_AREA between", value1, value2, "cityArea");
			return (Criteria) this;
		}

		public Criteria andCityAreaNotBetween(String value1, String value2) {
			addCriterion("CITY_AREA not between", value1, value2, "cityArea");
			return (Criteria) this;
		}

		public Criteria andDistrictIsNull() {
			addCriterion("DISTRICT is null");
			return (Criteria) this;
		}

		public Criteria andDistrictIsNotNull() {
			addCriterion("DISTRICT is not null");
			return (Criteria) this;
		}

		public Criteria andDistrictEqualTo(String value) {
			addCriterion("DISTRICT =", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictNotEqualTo(String value) {
			addCriterion("DISTRICT <>", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictGreaterThan(String value) {
			addCriterion("DISTRICT >", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictGreaterThanOrEqualTo(String value) {
			addCriterion("DISTRICT >=", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictLessThan(String value) {
			addCriterion("DISTRICT <", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictLessThanOrEqualTo(String value) {
			addCriterion("DISTRICT <=", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictLike(String value) {
			addCriterion("DISTRICT like", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictNotLike(String value) {
			addCriterion("DISTRICT not like", value, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictIn(List<String> values) {
			addCriterion("DISTRICT in", values, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictNotIn(List<String> values) {
			addCriterion("DISTRICT not in", values, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictBetween(String value1, String value2) {
			addCriterion("DISTRICT between", value1, value2, "district");
			return (Criteria) this;
		}

		public Criteria andDistrictNotBetween(String value1, String value2) {
			addCriterion("DISTRICT not between", value1, value2, "district");
			return (Criteria) this;
		}

		public Criteria andHousesNameIsNull() {
			addCriterion("HOUSES_NAME is null");
			return (Criteria) this;
		}

		public Criteria andHousesNameIsNotNull() {
			addCriterion("HOUSES_NAME is not null");
			return (Criteria) this;
		}

		public Criteria andHousesNameEqualTo(String value) {
			addCriterion("HOUSES_NAME =", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameNotEqualTo(String value) {
			addCriterion("HOUSES_NAME <>", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameGreaterThan(String value) {
			addCriterion("HOUSES_NAME >", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameGreaterThanOrEqualTo(String value) {
			addCriterion("HOUSES_NAME >=", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameLessThan(String value) {
			addCriterion("HOUSES_NAME <", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameLessThanOrEqualTo(String value) {
			addCriterion("HOUSES_NAME <=", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameLike(String value) {
			addCriterion("HOUSES_NAME like", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameNotLike(String value) {
			addCriterion("HOUSES_NAME not like", value, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameIn(List<String> values) {
			addCriterion("HOUSES_NAME in", values, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameNotIn(List<String> values) {
			addCriterion("HOUSES_NAME not in", values, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameBetween(String value1, String value2) {
			addCriterion("HOUSES_NAME between", value1, value2, "housesName");
			return (Criteria) this;
		}

		public Criteria andHousesNameNotBetween(String value1, String value2) {
			addCriterion("HOUSES_NAME not between", value1, value2,
					"housesName");
			return (Criteria) this;
		}

		public Criteria andPeriodsIsNull() {
			addCriterion("PERIODS is null");
			return (Criteria) this;
		}

		public Criteria andPeriodsIsNotNull() {
			addCriterion("PERIODS is not null");
			return (Criteria) this;
		}

		public Criteria andPeriodsEqualTo(Integer value) {
			addCriterion("PERIODS =", value, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsNotEqualTo(Integer value) {
			addCriterion("PERIODS <>", value, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsGreaterThan(Integer value) {
			addCriterion("PERIODS >", value, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsGreaterThanOrEqualTo(Integer value) {
			addCriterion("PERIODS >=", value, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsLessThan(Integer value) {
			addCriterion("PERIODS <", value, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsLessThanOrEqualTo(Integer value) {
			addCriterion("PERIODS <=", value, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsIn(List<Integer> values) {
			addCriterion("PERIODS in", values, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsNotIn(List<Integer> values) {
			addCriterion("PERIODS not in", values, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsBetween(Integer value1, Integer value2) {
			addCriterion("PERIODS between", value1, value2, "periods");
			return (Criteria) this;
		}

		public Criteria andPeriodsNotBetween(Integer value1, Integer value2) {
			addCriterion("PERIODS not between", value1, value2, "periods");
			return (Criteria) this;
		}

		public Criteria andPosBuildingIsNull() {
			addCriterion("POS_BUILDING is null");
			return (Criteria) this;
		}

		public Criteria andPosBuildingIsNotNull() {
			addCriterion("POS_BUILDING is not null");
			return (Criteria) this;
		}

		public Criteria andPosBuildingEqualTo(Integer value) {
			addCriterion("POS_BUILDING =", value, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingNotEqualTo(Integer value) {
			addCriterion("POS_BUILDING <>", value, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingGreaterThan(Integer value) {
			addCriterion("POS_BUILDING >", value, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingGreaterThanOrEqualTo(Integer value) {
			addCriterion("POS_BUILDING >=", value, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingLessThan(Integer value) {
			addCriterion("POS_BUILDING <", value, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingLessThanOrEqualTo(Integer value) {
			addCriterion("POS_BUILDING <=", value, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingIn(List<Integer> values) {
			addCriterion("POS_BUILDING in", values, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingNotIn(List<Integer> values) {
			addCriterion("POS_BUILDING not in", values, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingBetween(Integer value1, Integer value2) {
			addCriterion("POS_BUILDING between", value1, value2, "posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosBuildingNotBetween(Integer value1, Integer value2) {
			addCriterion("POS_BUILDING not between", value1, value2,
					"posBuilding");
			return (Criteria) this;
		}

		public Criteria andPosUnitIsNull() {
			addCriterion("POS_UNIT is null");
			return (Criteria) this;
		}

		public Criteria andPosUnitIsNotNull() {
			addCriterion("POS_UNIT is not null");
			return (Criteria) this;
		}

		public Criteria andPosUnitEqualTo(Integer value) {
			addCriterion("POS_UNIT =", value, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitNotEqualTo(Integer value) {
			addCriterion("POS_UNIT <>", value, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitGreaterThan(Integer value) {
			addCriterion("POS_UNIT >", value, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitGreaterThanOrEqualTo(Integer value) {
			addCriterion("POS_UNIT >=", value, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitLessThan(Integer value) {
			addCriterion("POS_UNIT <", value, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitLessThanOrEqualTo(Integer value) {
			addCriterion("POS_UNIT <=", value, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitIn(List<Integer> values) {
			addCriterion("POS_UNIT in", values, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitNotIn(List<Integer> values) {
			addCriterion("POS_UNIT not in", values, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitBetween(Integer value1, Integer value2) {
			addCriterion("POS_UNIT between", value1, value2, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosUnitNotBetween(Integer value1, Integer value2) {
			addCriterion("POS_UNIT not between", value1, value2, "posUnit");
			return (Criteria) this;
		}

		public Criteria andPosFloorIsNull() {
			addCriterion("POS_FLOOR is null");
			return (Criteria) this;
		}

		public Criteria andPosFloorIsNotNull() {
			addCriterion("POS_FLOOR is not null");
			return (Criteria) this;
		}

		public Criteria andPosFloorEqualTo(Integer value) {
			addCriterion("POS_FLOOR =", value, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorNotEqualTo(Integer value) {
			addCriterion("POS_FLOOR <>", value, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorGreaterThan(Integer value) {
			addCriterion("POS_FLOOR >", value, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorGreaterThanOrEqualTo(Integer value) {
			addCriterion("POS_FLOOR >=", value, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorLessThan(Integer value) {
			addCriterion("POS_FLOOR <", value, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorLessThanOrEqualTo(Integer value) {
			addCriterion("POS_FLOOR <=", value, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorIn(List<Integer> values) {
			addCriterion("POS_FLOOR in", values, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorNotIn(List<Integer> values) {
			addCriterion("POS_FLOOR not in", values, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorBetween(Integer value1, Integer value2) {
			addCriterion("POS_FLOOR between", value1, value2, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosFloorNotBetween(Integer value1, Integer value2) {
			addCriterion("POS_FLOOR not between", value1, value2, "posFloor");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoIsNull() {
			addCriterion("POS_ROOM_NO is null");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoIsNotNull() {
			addCriterion("POS_ROOM_NO is not null");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoEqualTo(Integer value) {
			addCriterion("POS_ROOM_NO =", value, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoNotEqualTo(Integer value) {
			addCriterion("POS_ROOM_NO <>", value, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoGreaterThan(Integer value) {
			addCriterion("POS_ROOM_NO >", value, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoGreaterThanOrEqualTo(Integer value) {
			addCriterion("POS_ROOM_NO >=", value, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoLessThan(Integer value) {
			addCriterion("POS_ROOM_NO <", value, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoLessThanOrEqualTo(Integer value) {
			addCriterion("POS_ROOM_NO <=", value, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoIn(List<Integer> values) {
			addCriterion("POS_ROOM_NO in", values, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoNotIn(List<Integer> values) {
			addCriterion("POS_ROOM_NO not in", values, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoBetween(Integer value1, Integer value2) {
			addCriterion("POS_ROOM_NO between", value1, value2, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosRoomNoNotBetween(Integer value1, Integer value2) {
			addCriterion("POS_ROOM_NO not between", value1, value2, "posRoomNo");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalIsNull() {
			addCriterion("POS_FLOOR_TOTAL is null");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalIsNotNull() {
			addCriterion("POS_FLOOR_TOTAL is not null");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalEqualTo(Integer value) {
			addCriterion("POS_FLOOR_TOTAL =", value, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalNotEqualTo(Integer value) {
			addCriterion("POS_FLOOR_TOTAL <>", value, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalGreaterThan(Integer value) {
			addCriterion("POS_FLOOR_TOTAL >", value, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalGreaterThanOrEqualTo(Integer value) {
			addCriterion("POS_FLOOR_TOTAL >=", value, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalLessThan(Integer value) {
			addCriterion("POS_FLOOR_TOTAL <", value, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalLessThanOrEqualTo(Integer value) {
			addCriterion("POS_FLOOR_TOTAL <=", value, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalIn(List<Integer> values) {
			addCriterion("POS_FLOOR_TOTAL in", values, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalNotIn(List<Integer> values) {
			addCriterion("POS_FLOOR_TOTAL not in", values, "posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalBetween(Integer value1, Integer value2) {
			addCriterion("POS_FLOOR_TOTAL between", value1, value2,
					"posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andPosFloorTotalNotBetween(Integer value1,
				Integer value2) {
			addCriterion("POS_FLOOR_TOTAL not between", value1, value2,
					"posFloorTotal");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumIsNull() {
			addCriterion("HOUSE_ROM_NUM is null");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumIsNotNull() {
			addCriterion("HOUSE_ROM_NUM is not null");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumEqualTo(Integer value) {
			addCriterion("HOUSE_ROM_NUM =", value, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumNotEqualTo(Integer value) {
			addCriterion("HOUSE_ROM_NUM <>", value, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumGreaterThan(Integer value) {
			addCriterion("HOUSE_ROM_NUM >", value, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumGreaterThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_ROM_NUM >=", value, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumLessThan(Integer value) {
			addCriterion("HOUSE_ROM_NUM <", value, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumLessThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_ROM_NUM <=", value, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumIn(List<Integer> values) {
			addCriterion("HOUSE_ROM_NUM in", values, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumNotIn(List<Integer> values) {
			addCriterion("HOUSE_ROM_NUM not in", values, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_ROM_NUM between", value1, value2, "houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseRomNumNotBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_ROM_NUM not between", value1, value2,
					"houseRomNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumIsNull() {
			addCriterion("HOUSE_HALL_NUM is null");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumIsNotNull() {
			addCriterion("HOUSE_HALL_NUM is not null");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumEqualTo(Integer value) {
			addCriterion("HOUSE_HALL_NUM =", value, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumNotEqualTo(Integer value) {
			addCriterion("HOUSE_HALL_NUM <>", value, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumGreaterThan(Integer value) {
			addCriterion("HOUSE_HALL_NUM >", value, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumGreaterThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_HALL_NUM >=", value, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumLessThan(Integer value) {
			addCriterion("HOUSE_HALL_NUM <", value, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumLessThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_HALL_NUM <=", value, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumIn(List<Integer> values) {
			addCriterion("HOUSE_HALL_NUM in", values, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumNotIn(List<Integer> values) {
			addCriterion("HOUSE_HALL_NUM not in", values, "houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_HALL_NUM between", value1, value2,
					"houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseHallNumNotBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_HALL_NUM not between", value1, value2,
					"houseHallNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumIsNull() {
			addCriterion("HOUSE_TOILET_NUM is null");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumIsNotNull() {
			addCriterion("HOUSE_TOILET_NUM is not null");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumEqualTo(Integer value) {
			addCriterion("HOUSE_TOILET_NUM =", value, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumNotEqualTo(Integer value) {
			addCriterion("HOUSE_TOILET_NUM <>", value, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumGreaterThan(Integer value) {
			addCriterion("HOUSE_TOILET_NUM >", value, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumGreaterThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_TOILET_NUM >=", value, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumLessThan(Integer value) {
			addCriterion("HOUSE_TOILET_NUM <", value, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumLessThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_TOILET_NUM <=", value, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumIn(List<Integer> values) {
			addCriterion("HOUSE_TOILET_NUM in", values, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumNotIn(List<Integer> values) {
			addCriterion("HOUSE_TOILET_NUM not in", values, "houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_TOILET_NUM between", value1, value2,
					"houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseToiletNumNotBetween(Integer value1,
				Integer value2) {
			addCriterion("HOUSE_TOILET_NUM not between", value1, value2,
					"houseToiletNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumIsNull() {
			addCriterion("HOUSE_BALCONY_NUM is null");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumIsNotNull() {
			addCriterion("HOUSE_BALCONY_NUM is not null");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumEqualTo(Integer value) {
			addCriterion("HOUSE_BALCONY_NUM =", value, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumNotEqualTo(Integer value) {
			addCriterion("HOUSE_BALCONY_NUM <>", value, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumGreaterThan(Integer value) {
			addCriterion("HOUSE_BALCONY_NUM >", value, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumGreaterThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_BALCONY_NUM >=", value, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumLessThan(Integer value) {
			addCriterion("HOUSE_BALCONY_NUM <", value, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumLessThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_BALCONY_NUM <=", value, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumIn(List<Integer> values) {
			addCriterion("HOUSE_BALCONY_NUM in", values, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumNotIn(List<Integer> values) {
			addCriterion("HOUSE_BALCONY_NUM not in", values, "houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_BALCONY_NUM between", value1, value2,
					"houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseBalconyNumNotBetween(Integer value1,
				Integer value2) {
			addCriterion("HOUSE_BALCONY_NUM not between", value1, value2,
					"houseBalconyNum");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceIsNull() {
			addCriterion("HOUSE_CAR_PLACE is null");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceIsNotNull() {
			addCriterion("HOUSE_CAR_PLACE is not null");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceEqualTo(Integer value) {
			addCriterion("HOUSE_CAR_PLACE =", value, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceNotEqualTo(Integer value) {
			addCriterion("HOUSE_CAR_PLACE <>", value, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceGreaterThan(Integer value) {
			addCriterion("HOUSE_CAR_PLACE >", value, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceGreaterThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_CAR_PLACE >=", value, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceLessThan(Integer value) {
			addCriterion("HOUSE_CAR_PLACE <", value, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceLessThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_CAR_PLACE <=", value, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceIn(List<Integer> values) {
			addCriterion("HOUSE_CAR_PLACE in", values, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceNotIn(List<Integer> values) {
			addCriterion("HOUSE_CAR_PLACE not in", values, "houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_CAR_PLACE between", value1, value2,
					"houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseCarPlaceNotBetween(Integer value1,
				Integer value2) {
			addCriterion("HOUSE_CAR_PLACE not between", value1, value2,
					"houseCarPlace");
			return (Criteria) this;
		}

		public Criteria andHouseAreaIsNull() {
			addCriterion("HOUSE_AREA is null");
			return (Criteria) this;
		}

		public Criteria andHouseAreaIsNotNull() {
			addCriterion("HOUSE_AREA is not null");
			return (Criteria) this;
		}

		public Criteria andHouseAreaEqualTo(Float value) {
			addCriterion("HOUSE_AREA =", value, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaNotEqualTo(Float value) {
			addCriterion("HOUSE_AREA <>", value, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaGreaterThan(Float value) {
			addCriterion("HOUSE_AREA >", value, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaGreaterThanOrEqualTo(Float value) {
			addCriterion("HOUSE_AREA >=", value, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaLessThan(Float value) {
			addCriterion("HOUSE_AREA <", value, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaLessThanOrEqualTo(Float value) {
			addCriterion("HOUSE_AREA <=", value, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaIn(List<Float> values) {
			addCriterion("HOUSE_AREA in", values, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaNotIn(List<Float> values) {
			addCriterion("HOUSE_AREA not in", values, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaBetween(Float value1, Float value2) {
			addCriterion("HOUSE_AREA between", value1, value2, "houseArea");
			return (Criteria) this;
		}

		public Criteria andHouseAreaNotBetween(Float value1, Float value2) {
			addCriterion("HOUSE_AREA not between", value1, value2, "houseArea");
			return (Criteria) this;
		}

		public Criteria andOrientationsIsNull() {
			addCriterion("ORIENTATIONS is null");
			return (Criteria) this;
		}

		public Criteria andOrientationsIsNotNull() {
			addCriterion("ORIENTATIONS is not null");
			return (Criteria) this;
		}

		public Criteria andOrientationsEqualTo(Integer value) {
			addCriterion("ORIENTATIONS =", value, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsNotEqualTo(Integer value) {
			addCriterion("ORIENTATIONS <>", value, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsGreaterThan(Integer value) {
			addCriterion("ORIENTATIONS >", value, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsGreaterThanOrEqualTo(Integer value) {
			addCriterion("ORIENTATIONS >=", value, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsLessThan(Integer value) {
			addCriterion("ORIENTATIONS <", value, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsLessThanOrEqualTo(Integer value) {
			addCriterion("ORIENTATIONS <=", value, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsIn(List<Integer> values) {
			addCriterion("ORIENTATIONS in", values, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsNotIn(List<Integer> values) {
			addCriterion("ORIENTATIONS not in", values, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsBetween(Integer value1, Integer value2) {
			addCriterion("ORIENTATIONS between", value1, value2, "orientations");
			return (Criteria) this;
		}

		public Criteria andOrientationsNotBetween(Integer value1, Integer value2) {
			addCriterion("ORIENTATIONS not between", value1, value2,
					"orientations");
			return (Criteria) this;
		}

		public Criteria andHouseUsageIsNull() {
			addCriterion("HOUSE_USAGE is null");
			return (Criteria) this;
		}

		public Criteria andHouseUsageIsNotNull() {
			addCriterion("HOUSE_USAGE is not null");
			return (Criteria) this;
		}

		public Criteria andHouseUsageEqualTo(Integer value) {
			addCriterion("HOUSE_USAGE =", value, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageNotEqualTo(Integer value) {
			addCriterion("HOUSE_USAGE <>", value, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageGreaterThan(Integer value) {
			addCriterion("HOUSE_USAGE >", value, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageGreaterThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_USAGE >=", value, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageLessThan(Integer value) {
			addCriterion("HOUSE_USAGE <", value, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageLessThanOrEqualTo(Integer value) {
			addCriterion("HOUSE_USAGE <=", value, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageIn(List<Integer> values) {
			addCriterion("HOUSE_USAGE in", values, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageNotIn(List<Integer> values) {
			addCriterion("HOUSE_USAGE not in", values, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_USAGE between", value1, value2, "houseUsage");
			return (Criteria) this;
		}

		public Criteria andHouseUsageNotBetween(Integer value1, Integer value2) {
			addCriterion("HOUSE_USAGE not between", value1, value2,
					"houseUsage");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeIsNull() {
			addCriterion("BUILDING_TYPE is null");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeIsNotNull() {
			addCriterion("BUILDING_TYPE is not null");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeEqualTo(Integer value) {
			addCriterion("BUILDING_TYPE =", value, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeNotEqualTo(Integer value) {
			addCriterion("BUILDING_TYPE <>", value, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeGreaterThan(Integer value) {
			addCriterion("BUILDING_TYPE >", value, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeGreaterThanOrEqualTo(Integer value) {
			addCriterion("BUILDING_TYPE >=", value, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeLessThan(Integer value) {
			addCriterion("BUILDING_TYPE <", value, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeLessThanOrEqualTo(Integer value) {
			addCriterion("BUILDING_TYPE <=", value, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeIn(List<Integer> values) {
			addCriterion("BUILDING_TYPE in", values, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeNotIn(List<Integer> values) {
			addCriterion("BUILDING_TYPE not in", values, "buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeBetween(Integer value1, Integer value2) {
			addCriterion("BUILDING_TYPE between", value1, value2,
					"buildingType");
			return (Criteria) this;
		}

		public Criteria andBuildingTypeNotBetween(Integer value1, Integer value2) {
			addCriterion("BUILDING_TYPE not between", value1, value2,
					"buildingType");
			return (Criteria) this;
		}

		public Criteria andDecorationIsNull() {
			addCriterion("DECORATION is null");
			return (Criteria) this;
		}

		public Criteria andDecorationIsNotNull() {
			addCriterion("DECORATION is not null");
			return (Criteria) this;
		}

		public Criteria andDecorationEqualTo(Integer value) {
			addCriterion("DECORATION =", value, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationNotEqualTo(Integer value) {
			addCriterion("DECORATION <>", value, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationGreaterThan(Integer value) {
			addCriterion("DECORATION >", value, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationGreaterThanOrEqualTo(Integer value) {
			addCriterion("DECORATION >=", value, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationLessThan(Integer value) {
			addCriterion("DECORATION <", value, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationLessThanOrEqualTo(Integer value) {
			addCriterion("DECORATION <=", value, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationIn(List<Integer> values) {
			addCriterion("DECORATION in", values, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationNotIn(List<Integer> values) {
			addCriterion("DECORATION not in", values, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationBetween(Integer value1, Integer value2) {
			addCriterion("DECORATION between", value1, value2, "decoration");
			return (Criteria) this;
		}

		public Criteria andDecorationNotBetween(Integer value1, Integer value2) {
			addCriterion("DECORATION not between", value1, value2, "decoration");
			return (Criteria) this;
		}

		public Criteria andUserIdIsNull() {
			addCriterion("USER_ID is null");
			return (Criteria) this;
		}

		public Criteria andUserIdIsNotNull() {
			addCriterion("USER_ID is not null");
			return (Criteria) this;
		}

		public Criteria andUserIdEqualTo(String value) {
			addCriterion("USER_ID =", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotEqualTo(String value) {
			addCriterion("USER_ID <>", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdGreaterThan(String value) {
			addCriterion("USER_ID >", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdGreaterThanOrEqualTo(String value) {
			addCriterion("USER_ID >=", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdLessThan(String value) {
			addCriterion("USER_ID <", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdLessThanOrEqualTo(String value) {
			addCriterion("USER_ID <=", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdLike(String value) {
			addCriterion("USER_ID like", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotLike(String value) {
			addCriterion("USER_ID not like", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdIn(List<String> values) {
			addCriterion("USER_ID in", values, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotIn(List<String> values) {
			addCriterion("USER_ID not in", values, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdBetween(String value1, String value2) {
			addCriterion("USER_ID between", value1, value2, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotBetween(String value1, String value2) {
			addCriterion("USER_ID not between", value1, value2, "userId");
			return (Criteria) this;
		}

		public Criteria andCreateTimeIsNull() {
			addCriterion("CREATE_TIME is null");
			return (Criteria) this;
		}

		public Criteria andCreateTimeIsNotNull() {
			addCriterion("CREATE_TIME is not null");
			return (Criteria) this;
		}

		public Criteria andCreateTimeEqualTo(Date value) {
			addCriterion("CREATE_TIME =", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeNotEqualTo(Date value) {
			addCriterion("CREATE_TIME <>", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeGreaterThan(Date value) {
			addCriterion("CREATE_TIME >", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
			addCriterion("CREATE_TIME >=", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeLessThan(Date value) {
			addCriterion("CREATE_TIME <", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
			addCriterion("CREATE_TIME <=", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeIn(List<Date> values) {
			addCriterion("CREATE_TIME in", values, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeNotIn(List<Date> values) {
			addCriterion("CREATE_TIME not in", values, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeBetween(Date value1, Date value2) {
			addCriterion("CREATE_TIME between", value1, value2, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
			addCriterion("CREATE_TIME not between", value1, value2,
					"createTime");
			return (Criteria) this;
		}

		public Criteria andModTimeIsNull() {
			addCriterion("MOD_TIME is null");
			return (Criteria) this;
		}

		public Criteria andModTimeIsNotNull() {
			addCriterion("MOD_TIME is not null");
			return (Criteria) this;
		}

		public Criteria andModTimeEqualTo(Date value) {
			addCriterion("MOD_TIME =", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeNotEqualTo(Date value) {
			addCriterion("MOD_TIME <>", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeGreaterThan(Date value) {
			addCriterion("MOD_TIME >", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeGreaterThanOrEqualTo(Date value) {
			addCriterion("MOD_TIME >=", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeLessThan(Date value) {
			addCriterion("MOD_TIME <", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeLessThanOrEqualTo(Date value) {
			addCriterion("MOD_TIME <=", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeIn(List<Date> values) {
			addCriterion("MOD_TIME in", values, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeNotIn(List<Date> values) {
			addCriterion("MOD_TIME not in", values, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeBetween(Date value1, Date value2) {
			addCriterion("MOD_TIME between", value1, value2, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeNotBetween(Date value1, Date value2) {
			addCriterion("MOD_TIME not between", value1, value2, "modTime");
			return (Criteria) this;
		}

		public Criteria andDelFlagIsNull() {
			addCriterion("DEL_FLAG is null");
			return (Criteria) this;
		}

		public Criteria andDelFlagIsNotNull() {
			addCriterion("DEL_FLAG is not null");
			return (Criteria) this;
		}

		public Criteria andDelFlagEqualTo(Integer value) {
			addCriterion("DEL_FLAG =", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagNotEqualTo(Integer value) {
			addCriterion("DEL_FLAG <>", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagGreaterThan(Integer value) {
			addCriterion("DEL_FLAG >", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagGreaterThanOrEqualTo(Integer value) {
			addCriterion("DEL_FLAG >=", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagLessThan(Integer value) {
			addCriterion("DEL_FLAG <", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagLessThanOrEqualTo(Integer value) {
			addCriterion("DEL_FLAG <=", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagIn(List<Integer> values) {
			addCriterion("DEL_FLAG in", values, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagNotIn(List<Integer> values) {
			addCriterion("DEL_FLAG not in", values, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagBetween(Integer value1, Integer value2) {
			addCriterion("DEL_FLAG between", value1, value2, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagNotBetween(Integer value1, Integer value2) {
			addCriterion("DEL_FLAG not between", value1, value2, "delFlag");
			return (Criteria) this;
		}
	}

	/**
	 * This class was generated by MyBatis Generator. This class corresponds to the database table house_basic_info
	 * @mbggenerated
	 */
	public static class Criterion {
		private String condition;
		private Object value;
		private Object secondValue;
		private boolean noValue;
		private boolean singleValue;
		private boolean betweenValue;
		private boolean listValue;
		private String typeHandler;

		public String getCondition() {
			return condition;
		}

		public Object getValue() {
			return value;
		}

		public Object getSecondValue() {
			return secondValue;
		}

		public boolean isNoValue() {
			return noValue;
		}

		public boolean isSingleValue() {
			return singleValue;
		}

		public boolean isBetweenValue() {
			return betweenValue;
		}

		public boolean isListValue() {
			return listValue;
		}

		public String getTypeHandler() {
			return typeHandler;
		}

		protected Criterion(String condition) {
			super();
			this.condition = condition;
			this.typeHandler = null;
			this.noValue = true;
		}

		protected Criterion(String condition, Object value, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.typeHandler = typeHandler;
			if (value instanceof List<?>) {
				this.listValue = true;
			} else {
				this.singleValue = true;
			}
		}

		protected Criterion(String condition, Object value) {
			this(condition, value, null);
		}

		protected Criterion(String condition, Object value, Object secondValue,
				String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.secondValue = secondValue;
			this.typeHandler = typeHandler;
			this.betweenValue = true;
		}

		protected Criterion(String condition, Object value, Object secondValue) {
			this(condition, value, secondValue, null);
		}
	}

	/**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table house_basic_info
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
        @Override
        public Criteria andUserIdEqualTo(String value) {
			addCriterion("house_basic_info.USER_ID =", value, "userId");
			return (Criteria) this;
		}
        @Override
        public Criteria andDelFlagEqualTo(Integer value) {
        	addCriterion("house_basic_info.DEL_FLAG =", value, "delFlag");
        	return (Criteria) this;
        }
    }
}